How to: Change the default directory for saving files in Excel.
Solution:
Click the 'General' tab in 'Tools', 'Options...' and type a different directory name.
1) Select the 'Tools' menu and select 'Options...'.
2) Click the 'General' tab.
3) Type a different directory (folder) name in the 'Default File Location' box.
4) Click 'OK'.